#! /usr/bin/env python
# -*- coding: utf-8 -*-

company_name = '福建优力特材料有限公司'
obj_id = '1911619472663224322'
unit_id = '1911619473061683202'
create_dept = '1820379858379681793'
status = 1
type = 2



query_sql = '''
SELECT
    count(*) 
FROM
    hgyq_emergency.dual_m_pla_con_aud
WHERE
    is_deleted = 0 
    AND create_dept = "''' + create_dept + '''" 
    AND type = "''' + str(type) + '''"
    AND obj_id = "''' + obj_id + '''" 
    AND unit_id = "''' + unit_id + '''" 
    AND status = "''' + str(status) + '''"  
'''